package cn.ikun.mzw.jdbc;

import java.sql.*;

public class AddJdbcSelect {
    public static void main(String[] args) throws Exception{
        //1.加载驱动类
        Class.forName("com.mysql.jdbc.Driver");

        //2.获取连接
        String url="jdbc:mysql://localhost:3306/test?useSSL=false";
        String username="root";
        String password="root";
        Connection connection = DriverManager.getConnection(url, username, password);

        //3.创建陈述句对象
        Statement statement = connection.createStatement();

        //4.执行查询
        String sql= "SELECT id,username from `user` order by id asc ";
        ResultSet set = statement.executeQuery(sql);

        //5.获取数据
        while( set.next() ) {
            long id =  set.getLong(1);
            String name =set.getString(2);

            System.out.println("id="+id+",name="+name);

        }
    }
}
